@@ -1,4 +1,4 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 01:41 |
|
| 1 |
+# Generated by Django 3.2.4 on 2021-07-10 14:19 |
|
| 2 | 2 |
|
| 3 | 3 |
from django.db import migrations, models |
| 4 | 4 |
import shortuuidfield.fields |
@@ -1,4 +1,4 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 01:41 |
|
| 1 |
+# Generated by Django 3.2.4 on 2021-07-10 14:19 |
|
| 2 | 2 |
|
| 3 | 3 |
from django.db import migrations, models |
| 4 | 4 |
import jsonfield.fields |
@@ -38,8 +38,8 @@ class Migration(migrations.Migration): |
||
| 38 | 38 |
('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
| 39 | 39 |
('eqpt_id', shortuuidfield.fields.ShortUUIDField(blank=True, db_index=True, editable=False, help_text='设备唯一标识', max_length=22, null=True, unique=True)),
|
| 40 | 40 |
('point_id', models.CharField(blank=True, db_index=True, help_text='隔离点唯一标识', max_length=32, null=True, verbose_name='point_id')),
|
| 41 |
- ('macid', models.CharField(blank=True, help_text='设备号', max_length=255, null=True, verbose_name='macid')),
|
|
| 42 |
- ('sn', models.CharField(blank=True, help_text='序列号', max_length=255, null=True, verbose_name='sn')),
|
|
| 41 |
+ ('macid', models.CharField(blank=True, help_text='设备号', max_length=32, null=True, verbose_name='macid')),
|
|
| 42 |
+ ('sn', models.CharField(blank=True, help_text='序列号', max_length=32, null=True, verbose_name='sn')),
|
|
| 43 | 43 |
('active_status', models.IntegerField(choices=[(1, '已激活'), (0, '已离线')], default=0, help_text='激活状态', verbose_name='active_status')),
|
| 44 | 44 |
('active_at', models.DateTimeField(blank=True, help_text='激活时间', null=True, verbose_name='active_at')),
|
| 45 | 45 |
('name', models.CharField(blank=True, help_text='用户姓名', max_length=255, null=True, verbose_name='name')),
|
@@ -47,6 +47,7 @@ class Migration(migrations.Migration): |
||
| 47 | 47 |
('age', models.IntegerField(default=0, help_text='用户年龄', verbose_name='age')),
|
| 48 | 48 |
('phone', models.CharField(blank=True, db_index=True, help_text='用户电话', max_length=11, null=True, verbose_name='phone')),
|
| 49 | 49 |
('remark', models.CharField(blank=True, help_text='备注', max_length=255, null=True, verbose_name='remark')),
|
| 50 |
+ ('last_submit_at', models.DateTimeField(blank=True, help_text='上一次上报时间', null=True, verbose_name='last_submit_at')),
|
|
| 50 | 51 |
], |
| 51 | 52 |
options={
|
| 52 | 53 |
'verbose_name': '测温设备信息', |
@@ -54,14 +55,15 @@ class Migration(migrations.Migration): |
||
| 54 | 55 |
}, |
| 55 | 56 |
), |
| 56 | 57 |
migrations.CreateModel( |
| 57 |
- name='ThermometerMeasureInfo', |
|
| 58 |
+ name='ThermometerMeasureLogInfo', |
|
| 58 | 59 |
fields=[ |
| 59 | 60 |
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
| 60 | 61 |
('status', models.BooleanField(default=True, help_text='Status', verbose_name='status')),
|
| 61 | 62 |
('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
|
| 62 | 63 |
('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
| 63 |
- ('macid', models.CharField(blank=True, help_text='设备号', max_length=255, null=True, verbose_name='macid')),
|
|
| 64 |
- ('sn', models.CharField(blank=True, help_text='序列号', max_length=255, null=True, verbose_name='sn')),
|
|
| 64 |
+ ('point_id', models.CharField(blank=True, db_index=True, help_text='隔离点唯一标识', max_length=32, null=True, verbose_name='point_id')),
|
|
| 65 |
+ ('macid', models.CharField(blank=True, help_text='设备号', max_length=32, null=True, verbose_name='macid')),
|
|
| 66 |
+ ('sn', models.CharField(blank=True, help_text='序列号', max_length=32, null=True, verbose_name='sn')),
|
|
| 65 | 67 |
('temperature', models.FloatField(default=0, help_text='用户体温', verbose_name='temperature')),
|
| 66 | 68 |
], |
| 67 | 69 |
options={
|
@@ -69,4 +71,24 @@ class Migration(migrations.Migration): |
||
| 69 | 71 |
'verbose_name_plural': '测温记录信息', |
| 70 | 72 |
}, |
| 71 | 73 |
), |
| 74 |
+ migrations.CreateModel( |
|
| 75 |
+ name='ThermometerMeasureInfo', |
|
| 76 |
+ fields=[ |
|
| 77 |
+ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
| 78 |
+ ('status', models.BooleanField(default=True, help_text='Status', verbose_name='status')),
|
|
| 79 |
+ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
|
|
| 80 |
+ ('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
|
| 81 |
+ ('point_id', models.CharField(blank=True, db_index=True, help_text='隔离点唯一标识', max_length=32, null=True, verbose_name='point_id')),
|
|
| 82 |
+ ('point_measure_ymd', models.CharField(blank=True, db_index=True, help_text='隔离点测温日期', max_length=10, null=True, verbose_name='point_measure_ymd')),
|
|
| 83 |
+ ('point_measure_window', models.CharField(blank=True, db_index=True, help_text='隔离点测温时间段', max_length=16, null=True, verbose_name='point_measure_window')),
|
|
| 84 |
+ ('macid', models.CharField(blank=True, help_text='设备号', max_length=32, null=True, verbose_name='macid')),
|
|
| 85 |
+ ('sn', models.CharField(blank=True, help_text='序列号', max_length=32, null=True, verbose_name='sn')),
|
|
| 86 |
+ ('temperature', models.FloatField(default=0, help_text='用户体温', verbose_name='temperature')),
|
|
| 87 |
+ ], |
|
| 88 |
+ options={
|
|
| 89 |
+ 'verbose_name': '测温信息', |
|
| 90 |
+ 'verbose_name_plural': '测温信息', |
|
| 91 |
+ 'unique_together': {('point_id', 'point_measure_ymd', 'point_measure_window', 'macid')},
|
|
| 92 |
+ }, |
|
| 93 |
+ ), |
|
| 72 | 94 |
] |
@@ -1,18 +0,0 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 04:54 |
|
| 2 |
- |
|
| 3 |
-from django.db import migrations, models |
|
| 4 |
- |
|
| 5 |
- |
|
| 6 |
-class Migration(migrations.Migration): |
|
| 7 |
- |
|
| 8 |
- dependencies = [ |
|
| 9 |
- ('equipment', '0001_initial'),
|
|
| 10 |
- ] |
|
| 11 |
- |
|
| 12 |
- operations = [ |
|
| 13 |
- migrations.AddField( |
|
| 14 |
- model_name='thermometermeasureinfo', |
|
| 15 |
- name='point_id', |
|
| 16 |
- field=models.CharField(blank=True, db_index=True, help_text='隔离点唯一标识', max_length=32, null=True, verbose_name='point_id'), |
|
| 17 |
- ), |
|
| 18 |
- ] |
@@ -1,43 +0,0 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 05:32 |
|
| 2 |
- |
|
| 3 |
-from django.db import migrations, models |
|
| 4 |
- |
|
| 5 |
- |
|
| 6 |
-class Migration(migrations.Migration): |
|
| 7 |
- |
|
| 8 |
- dependencies = [ |
|
| 9 |
- ('equipment', '0002_thermometermeasureinfo_point_id'),
|
|
| 10 |
- ] |
|
| 11 |
- |
|
| 12 |
- operations = [ |
|
| 13 |
- migrations.CreateModel( |
|
| 14 |
- name='ThermometerMeasureLogInfo', |
|
| 15 |
- fields=[ |
|
| 16 |
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
| 17 |
- ('status', models.BooleanField(default=True, help_text='Status', verbose_name='status')),
|
|
| 18 |
- ('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
|
|
| 19 |
- ('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
|
| 20 |
- ('point_id', models.CharField(blank=True, db_index=True, help_text='隔离点唯一标识', max_length=32, null=True, verbose_name='point_id')),
|
|
| 21 |
- ('macid', models.CharField(blank=True, help_text='设备号', max_length=255, null=True, verbose_name='macid')),
|
|
| 22 |
- ('sn', models.CharField(blank=True, help_text='序列号', max_length=255, null=True, verbose_name='sn')),
|
|
| 23 |
- ('temperature', models.FloatField(default=0, help_text='用户体温', verbose_name='temperature')),
|
|
| 24 |
- ], |
|
| 25 |
- options={
|
|
| 26 |
- 'verbose_name': '测温记录信息', |
|
| 27 |
- 'verbose_name_plural': '测温记录信息', |
|
| 28 |
- }, |
|
| 29 |
- ), |
|
| 30 |
- migrations.AlterModelOptions( |
|
| 31 |
- name='thermometermeasureinfo', |
|
| 32 |
- options={'verbose_name': '测温信息', 'verbose_name_plural': '测温信息'},
|
|
| 33 |
- ), |
|
| 34 |
- migrations.AddField( |
|
| 35 |
- model_name='thermometermeasureinfo', |
|
| 36 |
- name='point_measure_window', |
|
| 37 |
- field=models.CharField(blank=True, db_index=True, help_text='隔离点测温时间段', max_length=16, null=True, verbose_name='point_measure_window'), |
|
| 38 |
- ), |
|
| 39 |
- migrations.AlterUniqueTogether( |
|
| 40 |
- name='thermometermeasureinfo', |
|
| 41 |
- unique_together={('point_id', 'point_measure_window')},
|
|
| 42 |
- ), |
|
| 43 |
- ] |
@@ -1,17 +0,0 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 05:34 |
|
| 2 |
- |
|
| 3 |
-from django.db import migrations |
|
| 4 |
- |
|
| 5 |
- |
|
| 6 |
-class Migration(migrations.Migration): |
|
| 7 |
- |
|
| 8 |
- dependencies = [ |
|
| 9 |
- ('equipment', '0003_auto_20210709_1332'),
|
|
| 10 |
- ] |
|
| 11 |
- |
|
| 12 |
- operations = [ |
|
| 13 |
- migrations.AlterUniqueTogether( |
|
| 14 |
- name='thermometermeasureinfo', |
|
| 15 |
- unique_together={('point_id', 'point_measure_window', 'macid')},
|
|
| 16 |
- ), |
|
| 17 |
- ] |
@@ -1,18 +0,0 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 05:42 |
|
| 2 |
- |
|
| 3 |
-from django.db import migrations, models |
|
| 4 |
- |
|
| 5 |
- |
|
| 6 |
-class Migration(migrations.Migration): |
|
| 7 |
- |
|
| 8 |
- dependencies = [ |
|
| 9 |
- ('equipment', '0004_alter_thermometermeasureinfo_unique_together'),
|
|
| 10 |
- ] |
|
| 11 |
- |
|
| 12 |
- operations = [ |
|
| 13 |
- migrations.AddField( |
|
| 14 |
- model_name='thermometerequipmentinfo', |
|
| 15 |
- name='last_submit_at', |
|
| 16 |
- field=models.DateTimeField(blank=True, help_text='上一次上报时间', null=True, verbose_name='last_submit_at'), |
|
| 17 |
- ), |
|
| 18 |
- ] |
@@ -1,22 +0,0 @@ |
||
| 1 |
-# Generated by Django 3.2.4 on 2021-07-09 05:46 |
|
| 2 |
- |
|
| 3 |
-from django.db import migrations, models |
|
| 4 |
- |
|
| 5 |
- |
|
| 6 |
-class Migration(migrations.Migration): |
|
| 7 |
- |
|
| 8 |
- dependencies = [ |
|
| 9 |
- ('equipment', '0005_thermometerequipmentinfo_last_submit_at'),
|
|
| 10 |
- ] |
|
| 11 |
- |
|
| 12 |
- operations = [ |
|
| 13 |
- migrations.AddField( |
|
| 14 |
- model_name='thermometermeasureinfo', |
|
| 15 |
- name='point_measure_ymd', |
|
| 16 |
- field=models.CharField(blank=True, db_index=True, help_text='隔离点测温日期', max_length=10, null=True, verbose_name='point_measure_ymd'), |
|
| 17 |
- ), |
|
| 18 |
- migrations.AlterUniqueTogether( |
|
| 19 |
- name='thermometermeasureinfo', |
|
| 20 |
- unique_together={('point_id', 'point_measure_ymd', 'point_measure_window', 'macid')},
|
|
| 21 |
- ), |
|
| 22 |
- ] |